Tabela Service

Definicja tabeli Service

Name

Service

Code

Service

Comment

 


Lista kolumn tabeli Service

Name

Code

ID

ID

HospID

HospID

ExtID

ExtID

Descr

Descr

Active

Active

TypeID

TypeID

UpdUserID

UpdUserID

UpdNr

UpdNr

UpdDate

UpdDate

UpdTime

UpdTime

LockUserID

LockUserID

LockTime

LockTime

ICD

ICD

Points

Points

Price

Price


Kolumna ID tabeli Service

Definicja kolumny ID tabeli Service

Name

ID

Code

ID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna HospID tabeli Service

Definicja kolumny HospID tabeli Service

Name

HospID

Code

HospID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ExtID tabeli Service

Definicja kolumny ExtID tabeli Service

Name

ExtID

Code

ExtID

Data Type

VARCHAR2(64)

Mandatory

No

Comment

Zewnetrzny identyfikator uslugi


Kolumna Descr tabeli Service

Definicja kolumny Descr tabeli Service

Name

Descr

Code

Descr

Data Type

VARCHAR2(512)

Mandatory

No

Comment

 


Kolumna Active tabeli Service

Definicja kolumny Active tabeli Service

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna TypeID tabeli Service

Definicja kolumny TypeID tabeli Service

Name

TypeID

Code

TypeID

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna UpdUserID tabeli Service

Definicja kolumny UpdUserID tabeli Service

Name

UpdUserID

Code

UpdUserID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna UpdNr tabeli Service

Definicja kolumny UpdNr tabeli Service

Name

UpdNr

Code

UpdNr

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna UpdDate tabeli Service

Definicja kolumny UpdDate tabeli Service

Name

UpdDate

Code

UpdDate

Data Type

DATE

Mandatory

No

Comment

 


Kolumna UpdTime tabeli Service

Definicja kolumny UpdTime tabeli Service

Name

UpdTime

Code

UpdTime

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna LockUserID tabeli Service

Definicja kolumny LockUserID tabeli Service

Name

LockUserID

Code

LockUserID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LockTime tabeli Service

Definicja kolumny LockTime tabeli Service

Name

LockTime

Code

LockTime

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ICD tabeli Service

Definicja kolumny ICD tabeli Service

Name

ICD

Code

ICD

Data Type

VARCHAR2(10)

Mandatory

No

Comment

 


Kolumna Points tabeli Service

Definicja kolumny Points tabeli Service

Name

Points

Code

Points

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Price tabeli Service

Definicja kolumny Price tabeli Service

Name

Price

Code

Price

Data Type

NUMBER(19,4)

Mandatory

No

Comment

 


Lista kluczy tabeli Service

Name

Code

Primary

PK_Service_ID

PK_Service_ID

X


Klucz PK_Service_ID tabeli Service

Definicja klucza PK_Service_ID tabeli Service

Name

PK_Service_ID

Code

PK_Service_ID

Primary

Yes

Comment